SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[DnnProduct_CDS_DistributorConfigGetByName]
	@Name nvarchar(50)
AS
BEGIN
	SELECT [ID], [distID], [name], [disturl], [notifyurl], [sharedsecret], [AllowedIPAddress], [LocationDir],
		[DownloadURLDir], [DataPathDir], [PWDBName], [PWServerDN], [MaxDownloadsReached], [UsePW], [AllowedWebStore],
		[Description], [MaxLoanCount], [LinkExpires], [Deleted], [DownloadExpired]
	FROM [DISC_DistributorConfig]
	WHERE [name] = @Name
END
GO
